package br.com.fieo.sgee.model;

import java.io.Serializable;
import java.math.BigInteger;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
 * Classe para obter os Consumos, Estimativas e valores do Kwh Mensal
 * @author rbueno
 */
@Entity
@Table(name = "consumos_estimativas_kwhs")
@NamedQueries({
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findAll", query = "SELECT c FROM ConsumptionsEstimatesKwhs c"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findById", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.id = :id"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByEstimativaId", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.estimateId = :estimateId"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByValorEstimado", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.valueEstimate = :valueEstimate"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByKwhId", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.kwhId = :kwhId"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByValorKwh", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.valueKwh = :valueKwh"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByKwhs", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.kwhs = :kwhs"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByValorConsumido", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.valueConsumption = :valueConsumption"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByMes", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.month = :month"),
    @NamedQuery(name = "ConsumptionsEstimatesKwhs.findByAno", query = "SELECT c FROM ConsumptionsEstimatesKwhs c WHERE c.year = :year")
})
public class ConsumptionsEstimatesKwhs implements Serializable {

    private static final long serialVersionUID = 1L;
    @Basic(optional = false)
    @Column(name = "id")
    @Id
    private int id;
    @Basic(optional = false)
    @Column(name = "estimativa_id")
    private int estimateId;
    @Basic(optional = false)
    @Column(name = "valor_estimado")
    private float valueEstimate;
    @Basic(optional = false)
    @Column(name = "kwh_id")
    private int kwhId;
    @Basic(optional = false)
    @Column(name = "valor_kwh")
    private float valueKwh;
    @Column(name = "kwhs")
    private BigInteger kwhs;
    @Column(name = "valor_consumido")
    private Double valueConsumption;
    @Column(name = "mes")
    private Integer month;
    @Column(name = "ano")
    private Integer year;

    public int getEstimateId() {
        return estimateId;
    }

    public int getId() {
        return id;
    }

    public int getKwhId() {
        return kwhId;
    }

    public BigInteger getKwhs() {
        return kwhs;
    }

    public Integer getMonth() {
        return month;
    }

    public Double getValueConsumption() {
        return valueConsumption;
    }

    public float getValueEstimate() {
        return valueEstimate;
    }

    public float getValueKwh() {
        return valueKwh;
    }

    public Integer getYear() {
        return year;
    }

}
